﻿CREATE TABLE [dbo].[List_EventReceiver] (
    [ListID]          UNIQUEIDENTIFIER NOT NULL,
    [EventReceiverID] UNIQUEIDENTIFIER NOT NULL,
    CONSTRAINT [PK_List_EventReceiver] PRIMARY KEY CLUSTERED ([ListID] ASC, [EventReceiverID] ASC),
    CONSTRAINT [FK_List_EventReceiver_EventReceiver] FOREIGN KEY ([EventReceiverID]) REFERENCES [dbo].[EventReceiver] ([EventReceiverID]),
    CONSTRAINT [FK_List_EventReceiver_List] FOREIGN KEY ([ListID]) REFERENCES [dbo].[List] ([ListID])
);

